www.gusucode.com > ASP.net 专业开源的OA办公系统源码程序 > ASP.net 专业开源的OA办公系统源码程序\www.gusucodecom\oaPro\gxxz\upload\知识点.txt

    调用存储过程


IList<ArticalTypeInfo> lists = BLLGeneric.Select<ArticalTypeInfo>(CommandType.StoredProcedure, "ArticalTypeInfoList");
            this.gridArticalInfoList.DataSource = lists;
传参调用存储过程


  string loginName = this.txtLoginName.Text;
            string loginPwd = this.txtLoginPwd.Text;
            SqlParameter paramLoginName = new SqlParameter("@LoginName",loginName);
            SqlParameter paramLoginPwd = new SqlParameter("@LoginPwd",loginPwd);
            IList<UserInfo> lists = UserInfoBLL.Select(CommandType.StoredProcedure, "UserInfoLogin", paramLoginName, paramLoginPwd);

格式化WHERE

 String bumen=this.ddl_bumen.Text;
        String where = "em_dept_id='{0}'";
        where = string.Format(where,bumen);
        IList<employee> list = employeeBLL.Select(where);